package localdb.table
{
	import flash.data.SQLStatement;
	import flash.data.SQLResult;
	import flash.events.SQLErrorEvent;
	import flash.events.SQLEvent;
	import mx.collections.ArrayCollection;
	import localdb.dao.PageUpdateDAO;
	import asorm.db.LocalDatabase;
	import asorm.db.LocalDatabaseTable;

	public class PageUpdateTable extends LocalDatabaseTable
	{
		public static var TABLE_NAME: String = "page_update";
		
		private static var SQL_CREATE: String = 
			"CREATE TABLE IF NOT EXISTS " + TABLE_NAME + " ("
			+ "update_id INTEGER PRIMARY KEY AUTOINCREMENT, "
			+ "page_id TEXT NOT NULL, "
			+ "diff_text TEXT, "
			+ "modification_date DATE"
			+ ")";

		private static var DAO_PROPERTY_MAPPING: Object = {
				update_id:"updateId", 
				page_id:"pageId", 
				diff_text:"diffText",
				modification_date:"modificationDate"
			};
			
		public function PageUpdateTable(ldb: LocalDatabase) {
			super(ldb, TABLE_NAME, SQL_CREATE, DAO_PROPERTY_MAPPING);
		}
		
		
	}
}